Creating Visual Card 13

Adding Visual card for Sales Per month, YOY and GPM

Steps

Sales Per Month Visual Card

Ø  Open Visualization Pane

Ø  Select Visual Card

Ø  Drag the visual to the dashboard.

Ø  Click on Sales Per Month Measure and drag it into the fields.

Ø  General: X - Position = 2, Y - Position = 247, Width = 207, Height = 96

Ø  Data Label: Color = #12239E,  Value Decimal = 0, Font Size = 32,  Font type = DIN

Ø  Category = OFF

Ø  Title = ON,  Text Title = "Sales Per Month", Font Color = #000000 , Background Color = #cccccc ,   Font Size = 15 and Font Family = Segoe UI Bold, Alignment = Center

Ø  Background ON, Color = #ffffff, Transparency = 0
















Steps

YOY%

Ø  Open Visualization Pane

Ø  Select Visual Card

Ø  Drag the visual on to the dashboard.

Ø  Drag YOY% and place it inside the fields.

Ø  General: X - Position = 0, Y - Position = 383, Width = 207, Height = 110

Ø  Data Label: Color =#E66C37, Value decimal places = 1, Text Size = 32, Font Family = DIN

Ø  Category = OFF

Ø  Title ON, Text Title = "YOY % Sales", Font Color = #070606, Background Color = #cccccc, Alignment = Center, Text Size = 15 and Font Family = Segoe UI Bold

Ø  Background = ON, Color = #ffffff, Transparency = 0%




Steps

YOY Indicator

Ø  Open Visualization Pane

Ø  Select Visual Card

Ø  Drag the visual on to the dashboard.

Ø  Click on Arrow YOY% and place it inside the fields.

Ø  General: X - Position = 148, Y - Position = 417, Width = 70, Height = 50

Ø  Data Label: Text Size = 45, Font Family = DIN, Color:  IF YOY > 0 the Data Color will be #0D884D    OR   IF YOY < 0  the Data Color will be #D64550

Ø  Category = OFF, Background = OFF

Indicator Data Label Color Depend on the value of the value of YOY




Gross Profit Margin (GPM)

Ø  Open Visualization Pane

Ø  Select Visual Card

Ø  Drag the visual on to the dashboard.

Ø  Click on the GPM and drag it to the Fields.

ØCheck GPM if it is percentage.

Ø  General: X - Position = 0, Y - Position = 503, Width = 207, Height = 116

Ø  Data Label: Color =#D9B300, Value decimal places = 0, Text Size = 32, Font Family = DIN

Ø  Category = OFF

Ø  Title ON, Text Title = "Gross Profit Margin", Font Color = #070606, Background Color = #cccccc , Alignment = Center, Text Size = 15 and Font Family = Segoe UI Bold

Ø  Background = ON, Color = #ffffff, Transparency = 0%


Steps

Refreshed Date

Ø  Open Visualization Pane

Ø  Select Visual Card

Ø  Drag the visual to the dashboard.

Ø  Click on refreshed date from Data Refresh Table and place it inside the fields.

Ø  General: X - Position = 0, Y - Position =628, Width = 207, Height = 92

Ø  Drag the card to the bottom left corner.

Ø  Data Label: Color = #070606, Font Size = 15, Font type = DIN

Ø  Category = OFF

Ø  Title ON, Text Title = " Refreshed Date", Font Color = #070606, Background Color = #cccccc ,    Font Size = 14 and Font Family = Segoe UI Bold



Create a custom KPI Card in a Power BI report

https://www.youtube.com/watch?v=zHzSBNES6jE

How to Create a Card in Power BI

https://www.tutorialgateway.org/create-a-card-in-power-bi/

How to Add the Last Refreshed Date and Time to a Power BI Report

https://www.enhansoft.com/how-to-add-the-last-refreshed-date-and-time-to-a-power-bi-report/